Synchronize a "Calendar View" with Outlook 2007
Hi everyone,
I've few views created in one of my MOSS 2007 site calendar and I am trying to synchronize only one view from that calendar with Outlook 2007. When I synchronize with 'connect to' option from the calendar it takes all the events from that calendar (in other words NOT limited to my particular view). Is there any way only that filtered events are synchronized with Outlook?
Alternatively if I can create a new calendar based on that view (filtered events) I am fine too i.e. whatever changes made to the original calendar (hence the view in interest) the new calendar would reflect that. Thus avoiding creating a new calendar.
I would prefer solution with minimum programming involved. Any suggestions would be greatly appreciated.
Thank you in advance!
Daisy
January 3rd, 2010 10:50pm
Outlook currently doesn't understand the views in SharePoint so all content is synchronized. I haven't done it with a calendar, but I know with tasks you have the option of adding a custom filter on the client (Outlook) side. Try editing the properties of the connection and see if it gives you the option. SharePoint MVP | Developer | Administrator | Speaker-- Twitter -- Blog - http://nextconnect.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
January 3rd, 2010 11:32pm
There's a way to create a custom view in Outlook, if that's something you want to delve into. It depends on how many users need this view in Outlook. If the filter is based on some SharePoint field that Outlook doesn't know about, though, it won't be possible.I recommend creating a second calendar. Then, you can create a SharePoint designer workflow. Connect the workflow to the first calendar. What's the filter criteria? Whatever the filter criteria is, make that as the workflow condition. Then, the action would be to simply copy that item over to the other calendar.Laura Rogers, MCSE, MCTS
SharePoint911: SharePoint Consulting
Blog: http://www.sharepoint911.com/blogs/laura
Twitter: WonderLaura
January 4th, 2010 12:13pm
Thank you Mike for the clarification - I kind of guessed this as a limitation. Laura - Yes the filter is based on a custom sharepoint field. So I understand I'll have to take the Workflow solution you suggested. Do I create the 2nd Calendar with the same structure (as the existing calendar) first before I create the workflow? I would give this a try and let you know the outcome. Thank you very much!Daisy
Free Windows Admin Tool Kit Click here and download it now
January 4th, 2010 1:00pm
Yes, it would be a great idea to save calendar #1 as a template (minus the data), and then create the 2nd calendar from that template.Laura Rogers, MCSE, MCTS
SharePoint911: SharePoint Consulting
Blog: http://www.sharepoint911.com/blogs/laura
Twitter: WonderLaura
January 4th, 2010 3:02pm
@Laura - it's great my 2nd calendar is updating with any update/ new insert to the 1st calendar. Exactly what I wanted. I just have one quick question to make this perfect: :)When I'm using 'Copy list item' - both the calendars seem need to be under the same site. Ideally I would prefer the 2nd calendar be on a different site (within the same site collection - but on a seperate tab). Is this something achievable? Thank you again - you are very helpful!Daisy
Free Windows Admin Tool Kit Click here and download it now
January 4th, 2010 11:25pm
Hi Laura,
I am following your suggestion on creating a second calendar and then having a workflow update that calendar from the main calendar. However, what happens if the data changes on a event that was copied over to the second calendar. How does the copied data
get updated to the changed data? Is there a workflow that can help update the record in the second calendar?
Thanks!
April 13th, 2012 5:15pm
When you create the copy of the calendar item and will need to refer to it later when a workflow needs to change the item, you should create an extra field in the second calendar called "Associated ID" or something, and hide this field. Then, when
the item first gets created as a copy, populate the "associated id" field with the ID of the item that you're copying. Then, you'd need to run a workflow "on change" and when a calendar item gets changed, then you'd have to use the "update item" action
and update the item where "Associated ID" is equal to the ID of the item that's getting changed.Laura Rogers
SharePoint911: SharePoint Consulting
Blog: http://www.sharepoint911.com/blogs/laura
Twitter: WonderLaura
Books:Beginning SharePoint 2010: Building Business Solutions with SharePoint
Using InfoPath 2010 with Microsoft SharePoint 2010 Step by Step
Free Windows Admin Tool Kit Click here and download it now
April 16th, 2012 11:57am
Hi Laura,
I created an "unique identifier" that copies to the new list. However, now I am doing recurring events and when the event is changed in the main calendar, the change does appear in the second calendar, however, the original event is still visible and
when you click on it you get the error "Item does not exist. It may have been deleted by another user." Do you have any ideas on how to get rid of the original event with the error or a different way to update
the second calendar?
Thanks!
May 1st, 2012 5:30pm


